﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SchoolLibrary.Entity.Person
{
    public class Writer : Person
    {
        public const string TABLE_NAME = "writer";

        public const string FIND_BOOK_WRITERS_BY_BOOK_ID = 
            "SELECT w.* FROM writer w INNER JOIN book_writer bw on bw.writer_id = w.id " +
            "WHERE bw.book_id = :bookId";
        public const string FIND_BY_ID = "select * from writer where id = :id";
        public const string FIND_ALL = "select * from writer";

    }
}
